LNG Storage Tank EPC Quotation System Development Based on VB.Net and SQL Server 2008R2

Columnar Storage in SQL Server 2012

SQL Server 2012 introduces a new index type called a column store index and new query operators that efficiently process batches of rows at a time. These two features together greatly improve the performance of typical data warehouse queries, in some cases by two orders of magnitude. This paper outlines the design of column store indexes and batch-mode processing and summarizes the key benefits...

Optimizing Storage Performance, Provisioning, and Manageability for Microsoft SQL Server

Microsoft® SQL ServerTM has become very popular as a database environment driving a broad range of mid-level business applications, ranging from Customer Relationship Management (CRM) to eCommerce and from Enterprise Resource Planning (ERP) to supply chain integration. The combination of affordability, performance, ease of deployment, and sophisticated analytical features has led to a significa...

SD-SQL Server: Scalable Distributed Database System

We present SD-SQL Server, a prototype scalable distributed database system. It let a relational table to grow over new storage nodes invisibly to the application. The evolution uses splits dynamically generating a distributed range partitioning of the table. The splits avoid the reorganization of a growing database, necessary for the current DBMSs and a headache for the administrators. We illus...

How System 11 SQL Server Became Fast

High performance and SMP scalability were key goals for the System 11 release of Sybase SQL Server. With System 11, Sybase has gone from about 1400 tpmC to 14000 tpmC. This leap in performance was achieved as a result of new features as well as extensive detailed performance studies and rework of the core server. Logical memory management via multiple buffer caches helped to fine tune the use o...

Server Storage Server Storage Server Storage Server